-- ----------------------------
-- Table structure for cron_task
-- ----------------------------
DROP TABLE IF EXISTS `cron_task`;
CREATE TABLE `cron_task` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `spec` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` int unsigned DEFAULT '0',
  `updated_at` int unsigned DEFAULT '0',
  `is_delete` tinyint(1) DEFAULT '0',
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `command` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `config` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '{}',
  `notify_status` tinyint(1) DEFAULT '0',
  `is_notify` tinyint(1) DEFAULT '0',
  `notify_config` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
  `worker_type` tinyint unsigned DEFAULT '0',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
  `do_status` tinyint(1) DEFAULT '0',
  `do_updated_at` int unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of cron_task
-- ----------------------------
BEGIN;
INSERT INTO `cron_task` VALUES (1, '1 * * * * *', 1656988016, 1657531779, 0, '每1分钟飞书通知', 1, '', '{\"type\":\"http\",\"url\":\"http://localhost/get?id=185702333412307029&start=2022-05-01&stop=2022-05-09\",\"method\":\"GET\",\"header\":{\"Content-type\":\"application/json\",\"Authorization\":\"1234\"}}', 1, 1, '[{\"type\":\"feishu\",\"data\":{\"isSuccess\":1,\"text\":\"监控调度系统测试例子\",\"link\":\"https://www.baidu.com/\",\"webHookUrl\":\"https://open.feishu.cn/open-apis/bot/v2/hook/a07205e2-2660-427e-8b14-d1a2d2f72922\"}}]', 1, '[]', 10, 1658373501);
INSERT INTO `cron_task` VALUES (2, '1/8 * * * * *', 1657508363, 1657531779, 0, '1测试-每分钟的1s执行-🍎', 0, '', '{\"type\":\"http\",\"url\":\"http://canal.mblock.cc/gerpgo/amazon/\",\"method\":\"GET\",\"header\":{\"Content-type\":\"application/json\",\"TOKEN\":\"1234\"}}', 1, 1, '[{\"type\":\"feishu\",\"data\":{\"isSuccess\":1,\"text\":\"监控调度系统测试2\",\"link\":\"https://www.baidu.com/\",\"webHookUrl\":\"https://open.feishu.cn/open-apis/bot/v2/hook/a07205e2-2660-427e-8b14-d1a2d2f72922\"}}]', 1, '[]', 4, 1657880221);
INSERT INTO `cron_task` VALUES (3, '5 * * * * *', 1657508669, 1657523902, 0, '测试-每分钟的1s执行-🍎', 0, '', '{}', 0, 1, '[{\"type\":\"dingtalk\",\"data\":{\"title\":\"[Alerting] xxx-server scuess\",\"text\":\"13612fc3cc5605e3\",\"link\":\"https://www.baidu.com/\",\"isAtAll\":true,\"robotToken\":\"4fc5802ab76ad19377457b961f4d8c9142a0e90c768d33c73cdac304f70841a4\",\"robotSecret\":\"SEC52300a280cbbb18103f433ce4a8d668850a3ecc9898b47d9cd895d2082ab7840\"}}]', 3, '[]', 0, 1657508669);
INSERT INTO `cron_task` VALUES (4, '1 * * * * *', 1657508804, 1657523902, 0, '测试-每分钟的1s执行-🍎', 0, '{\"ids\":[\"1\"],\"doStatus\":2,\"info\":{}}', '{\"type\":\"http\",\"url\":\"http://localhost/post\",\"method\":\"PATCH\",\"header\":{\"Content-type\":\"application/json\",\"TOKEN\":\"1234\"}}', 0, 1, '[{\"type\":\"feishu\",\"data\":{\"title\":\"[Alerting] xxx-server scuess\",\"text\":\"13612fc3cc5605e3\",\"link\":\"https://www.baidu.com/\",\"isAtAll\":true,\"webHookUrl\":\"https://open.feishu.cn/open-apis/bot/v2/hook/a07205e2-2660-427e-8b14-d1a2d2f72922\"}}]', 2, '[]', 1, 1657771034);
INSERT INTO `cron_task` VALUES (10, '1/5 * * * * *', 1657509472, 1657509472, 0, '4测试-每分钟的1s执行-🍎', 0, '', '{}', 0, 1, '[{\"type\":\"email\",\"data\":{\"to\":[\"10@qq.com\"],\"subject\":\"title\",\"body\":\"<html><body>hi</body></html>\"}}]', 1, '[]', 0, 1657509472);
INSERT INTO `cron_task` VALUES (185702333412307029, '1 * * * * *', 1657677419, 1657677419, 0, '4测试-每分钟的1s执行-🍎', 0, 'curl -H \"Content-type: application/json\" -X GET \"http://canal.mblock.cc/gerpgo/amazon/\" ;', '{}', 1, 0, '{}', 0, '[]', 1, 1657938582);
INSERT INTO `cron_task` VALUES (185702333412307030, '1 * * * * *', 1658372910, 1658372910, 0, '4测试-每分钟的1s执行-🍎', 0, '', '{}', 0, 0, '{}', 0, '[]', 0, 1658372910);
INSERT INTO `cron_task` VALUES (185702333412307031, '1 * * * * *', 1658373003, 1658373003, 0, '4测试-每分钟的1s执行-🍎', 0, '', '{}', 0, 0, '{}', 0, '[]', 0, 1658373003);
COMMIT;
